Data Analysis and Visualization for UK Traffic Commissioner Authorities

  • Tech Stack: Python, PowerBI, SQlite, MySQL, RDBMS, ETL.
  • Github URL: Project Link

  • Utilized Extract, Transform, Load (ETL) methodology to process diverse data sources, employing web scraping for structured insights.
  • Established a robust MySQL RDBMS from scratch, ensuring optimized data organization and efficiency through extensive transformation and curation.
  • Applied advanced techniques for data transformation, unveiling pivotal insights crucial for strategic decision-making.
  • Identified meaningful patterns and trends through comprehensive data analysis, contributing to actionable business recommendations.
  • Conducted detailed data analysis and implemented machine learning models to predict key metrics, achieving 97% accuracy through model optimization and feature engineering.
  • Ensured seamless knowledge transfer by meticulously documenting the data pipeline, methodologies, and insights.
  • Presented project findings coherently in written reports and oral presentations, enhancing stakeholder.